<?php defined('BASEPATH') or exit('No direct script access allowed');
class Channel_m extends MY_Model
{
	public function __construct(){
		parent::__construct();
		$this->set_table_name("channel");
	}

	public function getChannelListByDay($dayOfWeek){

		$sql = "SELECT l.* FROM l_channel l INNER JOIN l_channel_schedule s ON l.id=s.channel_id WHERE s.day = ?";

		return $this->db->query($sql, array( $dayOfWeek))->result();
	}
}